package com.jy.wms.dao;

import com.jy.wms.common.base.BaseDao;
import com.jy.wms.pojo.WmsReservoirUtilization;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Administrator on 2018/4/23.
 */
public interface WmsReservoirUtilizationMapper extends BaseDao<WmsReservoirUtilization>{
    /**
     * 分页查询
     * @param entity 实体
     * @return List<WmsReservoirUtilization>
     * */
    public List<WmsReservoirUtilization> baseSelectPage(@Param("WmsReservoirUtilization") WmsReservoirUtilization entity);

    /**
     * 查询库位数量
     * */
    public int getKwsl(@Param("kqmc") String kqmc);

    /**
     * 查询已使用库位
     * */
    public int getYslkw(@Param("kqmc") String kqmc);

    /**
     * 查询空闲库位
     * */
    public int getKxkw(@Param("kqmc") String kqmc);

    /**
     * 导出
     * */
    public List<WmsReservoirUtilization> exportWmsReservoirUtilization(@Param("WmsReservoirUtilization") WmsReservoirUtilization entity);
}
